{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":196,"n_cols":11,"rows_kept":196,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,6,0,9],[1,6,1,9],[23,1,23,2],[42,1,42,2],[61,1,61,2],[80,1,80,2],[99,1,99,2],[118,1,118,2],[137,1,137,2],[156,1,156,2],[175,1,175,2],[194,1,194,2],[195,1,195,3]]}
[null,"МАОУ \"Троельжанская СОШ\"",null,null,"Утвердил:","должность","директор"]
[{"$nulls":5},"фамилия","Мясникова Т.А."]
[null,null,null,"7-11 лет",null,"дата",12,1,2026]
[{"$nulls":6},"день","месяц","год"]
["День недели","Прием пищи","Раздел меню","Блюда","Вес блюда, г","Белки","Жиры","Углеводы","Калорийность","№ рецептуры","Цена"]
[1,"Завтрак","гор.блюдо","Биточки кур.с соусом /макар.изд",250,20.66,11.38,38.33,334,"412/435",82.1]
[]
[null,null,"гор.напиток","Напиток из шиповника ",200,0.7,0.3,22.8,97,519,9.71]
[null,null,"хлеб","Хлеб пшеничный /печенье ",90,6.78,6.12,59.4,321,"108/590",19.7]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E6:E12)","v":540},{"$f":"SUM(F6:F12)","v":28.14},{"$f":"SUM(G6:G12)","v":17.8},{"$f":"SUM(H6:H12)","v":120.53},{"$f":"SUM(I6:I12)","v":752},null,{"$f":"SUM(K6:K12)","v":111.51}]
[{"$f":"A6","v":1},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E14:E22)","v":0},0,0,0,0,null,{"$f":"SUM(K14:K22)","v":0}]
[{"$f":"A6","v":1},"Итого за день:",null,null,{"$f":"E13+E23","v":540},28.14,17.8,120.53,752,null,{"$f":"K13+K23","v":111.51}]
[2,"Завтрак","гор.блюдо","Салат из капусты с огурцом/тефтели из говядины/карт.пюре ",310,14.58,22.36,29.25,377,"1/106/388/429",100.51]
[]
[null,null,"гор.напиток","Чай с сахаром ",200,0.1,null,15,60,493,5]
[null,null,"хлеб","Хлеб пшеничный/хлеб ржаной",60,4.26,0.6,24.78,123,"108/109",6]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E25:E31)","v":570},18.94,22.96,69.03,560,null,{"$f":"SUM(K25:K31)","v":111.51}]
[{"$f":"A25","v":2},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E33:E41)","v":0},0,0,0,0,null,{"$f":"SUM(K33:K41)","v":0}]
[{"$f":"A25","v":2},"Итого за день:",null,null,{"$f":"E32+E42","v":570},18.94,22.96,69.03,560,null,{"$f":"K32+K42","v":111.51}]
[3,"Завтрак","гор.блюдо","Салат овощной с зел.горошком/кнели рыбные с соусом/рис отварной ",310,18.97,11.74,44.77,361,"69/334/435/414",90.65]
[]
[null,null,"гор.напиток","Компот из свежих  фруктов ",200,0.5,0.2,23.1,96,507,14.03]
[null,null,"хлеб","Хлеб пшеничный/хлеб ржаной",60,4,1,25,123,"108/109",6.83]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E44:E50)","v":570},23.47,12.94,92.87,580,null,{"$f":"SUM(K44:K50)","v":111.51}]
[{"$f":"A44","v":3},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E52:E60)","v":0},0,0,0,0,null,{"$f":"SUM(K52:K60)","v":0}]
[{"$f":"A44","v":3},"Итого за день:",null,null,{"$f":"E51+E61","v":570},23.47,12.94,92.87,580,null,{"$f":"K51+K61","v":111.51}]
[4,"Завтрак","гор.блюдо","Фрикадельки из кур с соусом /каша пшенная ",255,21.52,22.67,35.82,433,"410/435/258",78.87]
[]
[null,null,"гор.напиток","Чай с сахаром ",200,0,null,15,60,493,5]
[null,null,"хлеб","Хлеб пшеничный/яблоко ",130,2.68,0.64,24.56,118,"108/112",27.64]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E63:E69)","v":585},24.2,23.31,75.38,611,null,{"$f":"SUM(K63:K69)","v":111.51}]
[{"$f":"A63","v":4},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E71:E79)","v":0},0,0,0,0,null,{"$f":"SUM(K71:K79)","v":0}]
[{"$f":"A63","v":4},"Итого за день:",null,null,{"$f":"E70+E80","v":585},24.2,23.31,75.38,611,null,{"$f":"K70+K80","v":111.51}]
[5,"Завтрак","гор.блюдо","Салат из капусты с морковью /кнели из гов.с соусом /карт.пюре",310,25.66,27.71,432,432,"4/379/453/429",100.51]
[]
[null,null,"гор.напиток","Чай с сахаром ",200,0,null,15,60,493,5]
[null,null,"хлеб","Хлеб пшеничный/хлеб ржаной",60,4,1,25,123,"108/109",6]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E82:E88)","v":570},29.66,28.71,472,615,null,{"$f":"SUM(K82:K88)","v":111.51}]
[{"$f":"A82","v":5},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E90:E98)","v":0},0,0,0,0,null,{"$f":"SUM(K90:K98)","v":0}]
[{"$f":"A82","v":5},"Итого за день:",null,null,{"$f":"E89+E99","v":570},29.66,28.71,472,615,null,{"$f":"K89+K99","v":111.51}]
[1,"Завтрак","гор.блюдо","Биточки из гов с соусом/макар.изд",250,23.6,18.17,43.34,431,"381/435/291",88.62]
[]
[null,null,"гор.напиток","Чай с сахаром ",200,0,null,15,60,493,5]
[null,null,"хлеб","Хлеб пшеничный/пряник ",90,5.82,3.06,59.76,291,"108/589",17.89]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E101:E107)","v":540},29.42,21.23,118.1,782,null,{"$f":"SUM(K101:K107)","v":111.51}]
[{"$f":"A101","v":1},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E109:E117)","v":0},0,0,0,0,null,{"$f":"SUM(K109:K117)","v":0}]
[{"$f":"A101","v":1},"Итого за день:",null,null,{"$f":"E108+E118","v":540},29.42,21.23,118.1,782,null,{"$f":"K108+K118","v":111.51}]
[2,"Завтрак","гор.блюдо","Салат из огурцов /рыба, туш.с овощами /карт.пюре ",310,13.07,17.8,22.05,301,"17/343/429",100.51]
[]
[null,null,"гор.напиток","Чай с сахаром ",200,0,null,15,60,493,5]
[null,null,"хлеб","Хлеб пшеничный/хлеб ржаной",60,4,1,25,123,"108/109",6]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E120:E126)","v":570},17.07,18.8,62.05,484,null,{"$f":"SUM(K120:K126)","v":111.51}]
[{"$f":"A120","v":2},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E128:E136)","v":0},0,0,0,0,null,{"$f":"SUM(K128:K136)","v":0}]
[{"$f":"A120","v":2},"Итого за день:",null,null,{"$f":"E127+E137","v":570},17.07,18.8,62.05,484,null,{"$f":"K127+K137","v":111.51}]
[3,"Завтрак","гор.блюдо","Салат из капусты с морковью/кнели из кур с соусом /каша гречневая ",310,26.8,31.47,50.27,591,"4/411/435/237",95.8]
[]
[null,null,"гор.напиток","Напиток из шиповника ",200,1,0,23,97,519,9.71]
[null,null,"хлеб","Хлеб пшеничный/хлеб ржаной",60,4,1,25,123,"108/109",6]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E139:E145)","v":570},31.8,32.47,98.27,811,null,{"$f":"SUM(K139:K145)","v":111.51}]
[{"$f":"A139","v":3},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E147:E155)","v":0},0,0,0,0,null,{"$f":"SUM(K147:K155)","v":0}]
[{"$f":"A139","v":3},"Итого за день:",null,null,{"$f":"E146+E156","v":570},31.8,32.47,98.27,811,null,{"$f":"K146+K156","v":111.51}]
[4,"Завтрак","гор.блюдо","Салат из капусты с огурцом/шницели из гов с соусом/каша ячневая ",310,23.73,31.11,46.02,558,"1/106/381/453/255",100.51]
[]
[null,null,"гор.напиток","Чай с сахаром ",200,0,null,15,60,493,5]
[null,null,"хлеб","Хлеб пшеничный/хлеб ржаной",60,4,1,25,123,"108/109",6]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E158:E164)","v":570},27.73,32.11,86.02,741,null,{"$f":"SUM(K158:K164)","v":111.51}]
[{"$f":"A158","v":4},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E166:E174)","v":0},0,0,0,0,null,{"$f":"SUM(K166:K174)","v":0}]
[{"$f":"A158","v":4},"Итого за день:",null,null,{"$f":"E165+E175","v":570},27.73,32.11,86.02,741,null,{"$f":"K165+K175","v":111.51}]
[5,"Завтрак","гор.блюдо","Салат овощной с зел.гор./фрикадельки из кур.с соусом /рис отв.",315,20.35,23.36,47.25,481,"69/410/435/414",87.01]
[]
[null,null,"гор.напиток","Компот из смеси сухофруктов ",200,0.5,null,27,110,508,15.5]
[null,null,"хлеб","Хлеб пшеничный/хлеб ржаной",90,4,1,25,123,"108/109",9]
[null,null,"фрукты"]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E177:E183)","v":605},24.85,24.36,99.25,714,null,{"$f":"SUM(K177:K183)","v":111.51}]
[{"$f":"A177","v":5},"Обед","закуска"]
[null,null,"1 блюдо"]
[null,null,"2 блюдо"]
[null,null,"гарнир"]
[null,null,"напиток"]
[null,null,"хлеб бел."]
[null,null,"хлеб черн."]
[]
[]
[null,null,"итого",null,{"$f":"SUM(E185:E193)","v":0},0,0,0,0,null,{"$f":"SUM(K185:K193)","v":0}]
[{"$f":"A177","v":5},"Итого за день:",null,null,{"$f":"E184+E194","v":605},24.85,24.36,99.25,714,null,{"$f":"K184+K194","v":111.51}]
[null,"Среднее значение за период:",null,null,{"$f":"(E24+E43+E62+E81+E100+E119+E138+E157+E176+E195)/(IF(E24=0,0,1)+IF(E43=0,0,1)+IF(E62=0,0,1)+IF(E81=0,0,1)+IF(E100=0,0,1)+IF(E119=0,0,1)+IF(E138=0,0,1)+IF(E157=0,0,1)+IF(E176=0,0,1)+IF(E195=0,0,1))","v":569},25.528,23.469,129.35,665,null,{"$f":"(K24+K43+K62+K81+K100+K119+K138+K157+K176+K195)/(IF(K24=0,0,1)+IF(K43=0,0,1)+IF(K62=0,0,1)+IF(K81=0,0,1)+IF(K100=0,0,1)+IF(K119=0,0,1)+IF(K138=0,0,1)+IF(K157=0,0,1)+IF(K176=0,0,1)+IF(K195=0,0,1))","v":111.51}]